﻿<%@ Page Title="Listados" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true"
    CodeBehind="diagramaMesas.aspx.cs" Inherits="Restaurante.diagramaMesas" %>


<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">
</asp:Content>
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
    <h2>         
         <p id="titulo"> Diagrama de Mesas </p>
    </h2>
    <div  id="usuleft" Class="contTabla" style="width: 150px;
        float: left;">
        <table BORDERCOLOR  = "BLACK" >
            <tr>VEREDA
                <td>                
                    <asp:Button ID="Button1" runat="server" Text="1"  
                        style='width:50px; height:50px' BackColor="Lime" ToolTip="Disponible" />
                </td>
                <td>
                    <asp:Button ID="Button2" runat="server" Text="2"  
                        style='width:50px; height:50px' BackColor="Lime"/>
                </td>   
            </tr>
            <tr>
                <td>                
                    <asp:Button ID="Button3" runat="server" Text="3"  
                        style='width:50px; height:50px' BackColor="Lime" ToolTip="Disponible"/>
                </td>
                <td>
                    <asp:Button ID="Button4" runat="server" Text="4"  
                        style='width:50px; height:50px' BackColor="Lime" ToolTip="Disponible"/>
                </td>   
            </tr>
            <tr>
                <td>                
                    <asp:Button ID="Button5" runat="server" Text="5"  
                        style='width:50px; height:50px' BackColor="Lime" ToolTip="Disponible"/>
                </td>
                <td>
                    <asp:Button ID="Button6" runat="server" Text="6"  
                        style='width:50px; height:50px' BackColor="Lime" ToolTip="Disponible"/>
                </td>   
            </tr> 
        </table>
    </div>

    <div  id="usuleft" Class="contTabla" style="width: 500px;
        float: left;">
        <table BORDERCOLOR  = "BLACK" >
            <tr>SALON
                <td>                
                    <asp:Button ID="Button7" runat="server" Text="7" 
                        style='width:50px; height:50px' BackColor="Lime" ToolTip="Disponible" />
                </td>
                <td>
                    <asp:Button ID="Button8" runat="server" Text="8"  
                        style='width:50px; height:50px' BackColor="Lime" ToolTip="Disponible" />
                </td>   
            </tr>
            <tr>
                <td>                
                    <asp:Button ID="Button9" runat="server" Text="9"  
                        style='width:50px; height:50px' BackColor="Lime" ToolTip="Disponible" />
                </td>
                <td>
                    <asp:Button ID="Button10" runat="server" Text="10" 
                        style='width:50px; height:50px' BackColor="Lime" ToolTip="Disponible" />
                </td>   
            </tr>
            <tr>
                <td>                
                    <asp:Button ID="Button11" runat="server" Text="11" 
                        style='width:50px; height:50px' BackColor="Lime" ToolTip="Disponible" />
                </td>
                <td>
                    <asp:Button ID="Button12" runat="server" Text="12"  
                        style='width:50px; height:50px' BackColor="Lime" ToolTip="Disponible"/>
                </td>   
            </tr> 
            <tr>
                <td>                
                    <asp:Button ID="Button13" runat="server" Text="13" 
                        style='width:50px; height:50px' BackColor="Lime" ToolTip="Disponible" />
                </td>
                <td>
                    <asp:Button ID="Button14" runat="server" Text="14"  
                        style='width:50px; height:50px' BackColor="Lime" ToolTip="Disponible" />
                </td>   
            </tr> 
            <tr>
                <td>                
                    <asp:Button ID="Button15" runat="server" Text="15"  
                        style='width:50px; height:50px' BackColor="Lime" ToolTip="Disponible" />
                </td>
                <td>
                    <asp:Button ID="Button16" runat="server" Text="16"  
                        style='width:50px; height:50px' BackColor="Lime" ToolTip="Disponible"/>
                </td>   
            </tr> 
        </table>
    </div>

    <div  id="usuleft" Class="contTabla" style="width: 150px;
        float: right;">
        <table BORDERCOLOR  = "BLACK" >
            <tr>PATIO
                <td>                
                    <asp:Button ID="Button17" runat="server" Text="17"  
                        style='width:50px; height:50px' BackColor="Lime" ToolTip="Disponible"/>
                </td>
                <td>
                    <asp:Button ID="Button18" runat="server" Text="18"  
                        style='width:50px; height:50px' BackColor="Lime" ToolTip="Disponible"/>
                </td>   
            </tr>
            <tr>
                <td>                
                    <asp:Button ID="Button19" runat="server" Text="19"  
                        style='width:50px; height:50px' BackColor="Lime" ToolTip="Disponible"/>
                </td>
                <td>
                    <asp:Button ID="Button20" runat="server" Text="20"  
                        style='width:50px; height:50px' BackColor="Lime" ToolTip="Disponible"/>
                </td>   
            </tr>
            <tr>
                <td>                
                    <asp:Button ID="Button21" runat="server" Text="11"  
                        style='width:50px; height:50px' BackColor="Lime" ToolTip="Disponible"/>
                </td>
                <td>
                    <asp:Button ID="Button22" runat="server" Text="22"  
                        style='width:50px; height:50px' BackColor="Lime" ToolTip="Disponible"/>
                </td>   
            </tr> 
            <tr>
                <td>                
                    <asp:Button ID="Button23" runat="server" Text="23"  
                        style='width:50px; height:50px' BackColor="Lime" ToolTip="Disponible"/>
                </td>
                <td>
                    <asp:Button ID="Button24" runat="server" Text="24"  
                        style='width:50px; height:50px' BackColor="Lime" ToolTip="Disponible"/>
                </td>   
            </tr> 
            <tr>
                <td>                
                    <asp:Button ID="Button25" runat="server" Text="25"  
                        style='width:50px; height:50px' BackColor="Lime" ToolTip="Disponible"/>
                </td>
                <td>
                    <asp:Button ID="Button26" runat="server" Text="26"  
                        style='width:50px; height:50px' BackColor="Lime" ToolTip="Disponible"/>
                </td>   
            </tr> 
        </table>
    </div>   
    <div  id="usuleft" Class="contTabla" style="width: 100%;
        float: right;">  
     <br>       
     <asp:Button ID="btnCancelar" runat="server" Text="Volver" 
            onclick="btnCancelar_Click" />
    </div>   

    <asp:SqlDataSource ID="SqlDataSourceDiagramaMesas" runat="server" 
        ConnectionString="<%$ ConnectionStrings:BarCafe %>" 
        ProviderName="<%$ ConnectionStrings:BarCafe.ProviderName %>" 
        
        
        SelectCommand="select m.Id_Mesa mesa,  e.Id_Estado estado,e.Color Color,e.Descripcion desEstado
from comanda c join estado e on e.Id_Estado = c.Id_Estado  join Mesa m on  m.Id_Mesa = c.Id_Mesa join   Sector s on s.Id_Sector = m.Id_Sector   
where CONVERT(date, c.fecha) = CONVERT(date, GETDATE())
union all
select m.Id_Mesa mesa,  e.Id_Estado estado, e.Color Color,e.Descripcion desEstado
from Reserva r join estado e on e.Id_Estado = r.Id_Estado  join Mesa m on  m.Id_Mesa = r.Id_Mesa join   Sector s on s.Id_Sector = m.Id_Sector">
    </asp:SqlDataSource>

 </asp:Content>